Listings Profile Report

Dataset statistics

Number of variables	16
Number of observations	20030
Missing cells	24884
Missing cells (%)	7.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	128.0 B

Variable types

Numeric	10
Categorical	5
Unsupported	1

Alerts

`name` has a high cardinality: 19503 distinct values	High cardinality
`host_name` has a high cardinality: 5915 distinct values	High cardinality
`last_review` has a high cardinality: 1202 distinct values	High cardinality
`latitude` is highly overall correlated with `neighbourhood`	High correlation
`longitude` is highly overall correlated with `neighbourhood`	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`neighbourhood` is highly overall correlated with `latitude` and 1 other fields	High correlation
`room_type` is highly imbalanced (52.1%)	Imbalance
`neighbourhood_group` has 20030 (100.0%) missing values	Missing
`last_review` has 2406 (12.0%) missing values	Missing
`reviews_per_month` has 2406 (12.0%) missing values	Missing
`price` is highly skewed (γ1 = 25.44770219)	Skewed
`minimum_nights` is highly skewed (γ1 = 56.36139206)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`latitude` has unique values	Unique
`longitude` has unique values	Unique
`neighbourhood_group` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`number_of_reviews` has 2388 (11.9%) zeros	Zeros
`availability_365` has 9344 (46.7%) zeros	Zeros

Reproduction

Analysis started	2023-05-04 20:41:57.041415
Analysis finished	2023-05-04 20:42:16.129619
Duration	19.09 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

id
Real number (ℝ)

Distinct	20030
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15417254

Minimum	2818
Maximum	30580413
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	2818
5-th percentile	1355640.1
Q1	8188422.8
median	15630490
Q3	22025770
95-th percentile	29148116
Maximum	30580413
Range	30577595
Interquartile range (IQR)	13837348

Descriptive statistics

Standard deviation	8569403.6
Coefficient of variation (CV)	0.55583203
Kurtosis	-1.0603338
Mean	15417254
Median Absolute Deviation (MAD)	6836429
Skewness	-0.049708236
Sum	3.088076 × 10¹¹
Variance	7.3434678 × 10¹³
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2818	1	< 0.1%
19981710	1	< 0.1%
19989602	1	< 0.1%
19988595	1	< 0.1%
19987998	1	< 0.1%
19984655	1	< 0.1%
19984496	1	< 0.1%
19983345	1	< 0.1%
19982520	1	< 0.1%
19980693	1	< 0.1%
Other values (20020)	20020	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2818	1	< 0.1%
3209	1	< 0.1%
20168	1	< 0.1%
25428	1	< 0.1%
27886	1	< 0.1%
28658	1	< 0.1%
28871	1	< 0.1%
29051	1	< 0.1%
31080	1	< 0.1%
41125	1	< 0.1%

Value	Count	Frequency (%)
30580413	1	< 0.1%
30579673	1	< 0.1%
30578037	1	< 0.1%
30577727	1	< 0.1%
30576148	1	< 0.1%
30573892	1	< 0.1%
30563877	1	< 0.1%
30562689	1	< 0.1%
30562273	1	< 0.1%
30561688	1	< 0.1%

name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	19503
Distinct (%)	97.6%
Missing	38
Missing (%)	0.2%
Memory size	156.6 KiB

Amsterdam	39
Amsterdam Appartement	11
Lovely apartment near Vondelpark	8
Apartment in Amsterdam	7
Spacious apartment with garden	6
Other values (19498)	19921

Length

Max length	122
Median length	86
Mean length	37.887855
Min length	1

Characters and Unicode

Total characters	757454
Distinct characters	182
Distinct categories	20 ?
Distinct scripts	7 ?
Distinct blocks	14 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19174 ?
Unique (%)	95.9%

Sample

1st row	Quiet Garden View Room & Super Fast WiFi
2nd row	Quiet apt near center, great view
3rd row	100%Centre-Studio 1 Private Floor/Bathroom
4th row	Lovely apt in City Centre (Jordaan)
5th row	Romantic, stylish B&B houseboat in canal district

Common Values

Value	Count	Frequency (%)
Amsterdam	39	0.2%
Amsterdam Appartement	11	0.1%
Lovely apartment near Vondelpark	8	< 0.1%
Apartment in Amsterdam	7	< 0.1%
Spacious apartment with garden	6	< 0.1%
Beautiful apartment in Amsterdam	6	< 0.1%
Beautiful apartment near Vondelpark	6	< 0.1%
Amsterdam Apartment	6	< 0.1%
Spacious apartment in Amsterdam	6	< 0.1%
Cosy apartment in Amsterdam West	5	< 0.1%
Other values (19493)	19892	99.3%
(Missing)	38	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
apartment	7792	6.5%
in	6599	5.5%
amsterdam	4527	3.8%
	3924	3.3%
with	2991	2.5%
the	2436	2.0%
spacious	2293	1.9%
city	2068	1.7%
room	1890	1.6%
centre	1860	1.6%
Other values (5172)	82662	69.4%

Most occurring characters

Value	Count	Frequency (%)
	99532	13.1%
e	65900	8.7%
t	61721	8.1%
a	58168	7.7%
r	48161	6.4%
n	43803	5.8%
o	40023	5.3%
i	36552	4.8%
m	30294	4.0%
s	24205	3.2%
Other values (172)	249095	32.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	570345	75.3%
Space Separator	99536	13.1%
Uppercase Letter	64139	8.5%
Other Punctuation	11726	1.5%
Decimal Number	6389	0.8%
Dash Punctuation	1905	0.3%
Math Symbol	1509	0.2%
Close Punctuation	760	0.1%
Open Punctuation	733	0.1%
Other Symbol	224	< 0.1%
Other values (10)	188	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
ﾑ	2	4.7%
到	2	4.7%
年	2	4.7%
交	1	2.3%
公	1	2.3%
坐	1	2.3%
中	1	2.3%
北	1	2.3%
心	1	2.3%
站	1	2.3%
Other values (30)	30	69.8%

Lowercase Letter

Value	Count	Frequency (%)
e	65900	11.6%
t	61721	10.8%
a	58168	10.2%
r	48161	8.4%
n	43803	7.7%
o	40023	7.0%
i	36552	6.4%
m	30294	5.3%
s	24205	4.2%
p	21598	3.8%
Other values (23)	139920	24.5%

Uppercase Letter

Value	Count	Frequency (%)
A	10601	16.5%
C	7461	11.6%
S	5049	7.9%
B	3724	5.8%
L	3705	5.8%
R	3353	5.2%
P	3222	5.0%
E	2943	4.6%
T	2695	4.2%
N	2596	4.0%
Other values (19)	18790	29.3%

Other Symbol

Value	Count	Frequency (%)
★	152	67.9%
☆	24	10.7%
❤	18	8.0%
♥	7	3.1%
☘	4	1.8%
●	3	1.3%
✿	2	0.9%
°	2	0.9%
⏹	2	0.9%
☟	1	0.4%
Other values (9)	9	4.0%

Other Punctuation

Value	Count	Frequency (%)
,	3059	26.1%
!	2581	22.0%
&	2003	17.1%
.	1442	12.3%
'	878	7.5%
/	658	5.6%
@	370	3.2%
"	274	2.3%
:	214	1.8%
*	143	1.2%
Other values (7)	104	0.9%

Decimal Number

Value	Count	Frequency (%)
2	2227	34.9%
1	1146	17.9%
0	877	13.7%
5	551	8.6%
3	491	7.7%
4	465	7.3%
9	170	2.7%
8	155	2.4%
7	154	2.4%
6	153	2.4%

Math Symbol

Value	Count	Frequency (%)
\|	802	53.1%
+	677	44.9%
~	10	0.7%
<	9	0.6%
=	4	0.3%
>	3	0.2%
±	2	0.1%
￫	1	0.1%
≠	1	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	752	98.9%
]	7	0.9%
】	1	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	725	98.9%
[	7	1.0%
【	1	0.1%

Modifier Symbol

Value	Count	Frequency (%)
`	3	37.5%
˜	3	37.5%
´	2	25.0%

Space Separator

Value	Count	Frequency (%)
	99532	> 99.9%
	4	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1900	99.7%
–	5	0.3%

Final Punctuation

Value	Count	Frequency (%)
’	44	86.3%
”	7	13.7%

Nonspacing Mark

Value	Count	Frequency (%)
️	18	94.7%
︎	1	5.3%

Initial Punctuation

Value	Count	Frequency (%)
‘	13	65.0%
“	7	35.0%

Currency Symbol

Value	Count	Frequency (%)
€	1	50.0%
$	1	50.0%

Other Number

Value	Count	Frequency (%)
²	22	100.0%

Control

Value	Count	Frequency (%)
	18	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Modifier Letter

Value	Count	Frequency (%)
ﾞ	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	634482	83.8%
Common	122908	16.2%
Han	34	< 0.1%
Inherited	19	< 0.1%
Katakana	7	< 0.1%
Cyrillic	2	< 0.1%
Hiragana	2	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
	99532	81.0%
,	3059	2.5%
!	2581	2.1%
2	2227	1.8%
&	2003	1.6%
-	1900	1.5%
.	1442	1.2%
1	1146	0.9%
'	878	0.7%
0	877	0.7%
Other values (68)	7263	5.9%

Latin

Value	Count	Frequency (%)
e	65900	10.4%
t	61721	9.7%
a	58168	9.2%
r	48161	7.6%
n	43803	6.9%
o	40023	6.3%
i	36552	5.8%
m	30294	4.8%
s	24205	3.8%
p	21598	3.4%
Other values (50)	204057	32.2%

Han

Value	Count	Frequency (%)
到	2	5.9%
年	2	5.9%
交	1	2.9%
公	1	2.9%
坐	1	2.9%
中	1	2.9%
北	1	2.9%
心	1	2.9%
站	1	2.9%
丹	1	2.9%
Other values (22)	22	64.7%

Katakana

Value	Count	Frequency (%)
ﾑ	2	28.6%
ｱ	1	14.3%
ｽ	1	14.3%
ﾃ	1	14.3%
ﾙ	1	14.3%
ﾀ	1	14.3%

Inherited

Value	Count	Frequency (%)
️	18	94.7%
︎	1	5.3%

Cyrillic

Value	Count	Frequency (%)
м	1	50.0%
А	1	50.0%

Hiragana

Value	Count	Frequency (%)
を	1	50.0%
で	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	756980	99.9%
Misc Symbols	191	< 0.1%
Punctuation	99	< 0.1%
None	92	< 0.1%
CJK	34	< 0.1%
Dingbats	24	< 0.1%
VS	19	< 0.1%
Modifier Letters	3	< 0.1%
Geometric Shapes	3	< 0.1%
Misc Technical	3	< 0.1%
Other values (4)	6	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	99532	13.1%
e	65900	8.7%
t	61721	8.2%
a	58168	7.7%
r	48161	6.4%
n	43803	5.8%
o	40023	5.3%
i	36552	4.8%
m	30294	4.0%
s	24205	3.2%
Other values (82)	248621	32.8%

Misc Symbols

Value	Count	Frequency (%)
★	152	79.6%
☆	24	12.6%
♥	7	3.7%
☘	4	2.1%
☟	1	0.5%
☼	1	0.5%
♛	1	0.5%
♡	1	0.5%

Punctuation

Value	Count	Frequency (%)
’	44	44.4%
•	23	23.2%
‘	13	13.1%
“	7	7.1%
”	7	7.1%
–	5	5.1%

None

Value	Count	Frequency (%)
é	27	29.3%
²	22	23.9%
É	4	4.3%
	4	4.3%
·	4	4.3%
à	3	3.3%
ﾑ	2	2.2%
°	2	2.2%
ü	2	2.2%
´	2	2.2%
Other values (16)	20	21.7%

VS

Value	Count	Frequency (%)
️	18	94.7%
︎	1	5.3%

Dingbats

Value	Count	Frequency (%)
❤	18	75.0%
✿	2	8.3%
✭	1	4.2%
✓	1	4.2%
❣	1	4.2%
✯	1	4.2%

Modifier Letters

Value	Count	Frequency (%)
˜	3	100.0%

Geometric Shapes

Value	Count	Frequency (%)
●	3	100.0%

CJK

Value	Count	Frequency (%)
到	2	5.9%
年	2	5.9%
交	1	2.9%
公	1	2.9%
坐	1	2.9%
中	1	2.9%
北	1	2.9%
心	1	2.9%
站	1	2.9%
丹	1	2.9%
Other values (22)	22	64.7%

Misc Technical

Value	Count	Frequency (%)
⏹	2	66.7%
⏺	1	33.3%

Cyrillic

Value	Count	Frequency (%)
м	1	50.0%
А	1	50.0%

Hiragana

Value	Count	Frequency (%)
を	1	50.0%
で	1	50.0%

Math Operators

Value	Count	Frequency (%)
≠	1	100.0%

Currency Symbols

Value	Count	Frequency (%)
€	1	100.0%

host_id
Real number (ℝ)

Distinct	17264
Distinct (%)	86.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48685695

Minimum	3159
Maximum	2.2936124 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	3159
5-th percentile	1725242
Q1	8093515.8
median	23694499
Q3	68275352
95-th percentile	1.8463359 × 10⁸
Maximum	2.2936124 × 10⁸
Range	2.2935808 × 10⁸
Interquartile range (IQR)	60181836

Descriptive statistics

Standard deviation	56496353
Coefficient of variation (CV)	1.1604302
Kurtosis	1.4522264
Mean	48685695
Median Absolute Deviation (MAD)	19349992
Skewness	1.5226291
Sum	9.7517448 × 10¹¹
Variance	3.1918379 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65859990	208	1.0%
1464510	105	0.5%
76104209	83	0.4%
113977564	38	0.2%
517215	30	0.1%
107745142	27	0.1%
14183886	25	0.1%
11969034	24	0.1%
44168250	21	0.1%
7594884	21	0.1%
Other values (17254)	19448	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3159	1	< 0.1%
3806	1	< 0.1%
5988	1	< 0.1%
12085	1	< 0.1%
20405	1	< 0.1%
30390	1	< 0.1%
34080	1	< 0.1%
36701	1	< 0.1%
47517	1	< 0.1%
49851	1	< 0.1%

Value	Count	Frequency (%)
229361236	1	< 0.1%
229295710	1	< 0.1%
229260989	1	< 0.1%
229196646	5	< 0.1%
229109698	1	< 0.1%
229053056	4	< 0.1%
229026227	1	< 0.1%
229023758	1	< 0.1%
228892275	1	< 0.1%
228856945	1	< 0.1%

host_name
Categorical

Distinct	5915
Distinct (%)	29.5%
Missing	4
Missing (%)	< 0.1%
Memory size	156.6 KiB

Martijn	289
Michiel And Jane	105
Laura	98
Anne	90
Marieke	88
Other values (5910)	19356

Length

Max length	34
Median length	30
Mean length	6.2987616
Min length	1

Characters and Unicode

Total characters	126139
Distinct characters	103
Distinct categories	13 ?
Distinct scripts	4 ?
Distinct blocks	5 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3662 ?
Unique (%)	18.3%

Sample

1st row	Daniel
2nd row	Maartje
3rd row	Alex
4th row	Joan
5th row	Flip

Common Values

Value	Count	Frequency (%)
Martijn	289	1.4%
Michiel And Jane	105	0.5%
Laura	98	0.5%
Anne	90	0.4%
Marieke	88	0.4%
Eva	88	0.4%
Willem	87	0.4%
Rated	83	0.4%
Thomas	80	0.4%
David	77	0.4%
Other values (5905)	18941	94.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	715	3.1%
martijn	296	1.3%
and	234	1.0%
michiel	183	0.8%
en	137	0.6%
jan	125	0.5%
jane	110	0.5%
laura	109	0.5%
willem	105	0.5%
anne	104	0.5%
Other values (5299)	20786	90.8%

Most occurring characters

Value	Count	Frequency (%)
a	14096	11.2%
e	14076	11.2%
i	10788	8.6%
n	10549	8.4%
r	8367	6.6%
l	5733	4.5%
o	5579	4.4%
t	4821	3.8%
s	4089	3.2%
M	3150	2.5%
Other values (93)	44891	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	99519	78.9%
Uppercase Letter	22532	17.9%
Space Separator	2888	2.3%
Other Punctuation	913	0.7%
Dash Punctuation	155	0.1%
Open Punctuation	50	< 0.1%
Close Punctuation	50	< 0.1%
Decimal Number	12	< 0.1%
Math Symbol	10	< 0.1%
Other Symbol	6	< 0.1%
Other values (3)	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14096	14.2%
e	14076	14.1%
i	10788	10.8%
n	10549	10.6%
r	8367	8.4%
l	5733	5.8%
o	5579	5.6%
t	4821	4.8%
s	4089	4.1%
u	2569	2.6%
Other values (42)	18852	18.9%

Uppercase Letter

Value	Count	Frequency (%)
M	3150	14.0%
J	2136	9.5%
A	1893	8.4%
S	1752	7.8%
R	1429	6.3%
E	1263	5.6%
L	1253	5.6%
C	952	4.2%
D	949	4.2%
B	888	3.9%
Other values (20)	6867	30.5%

Other Punctuation

Value	Count	Frequency (%)
&	768	84.1%
.	95	10.4%
,	35	3.8%
'	8	0.9%
/	6	0.7%
@	1	0.1%

Decimal Number

Value	Count	Frequency (%)
1	6	50.0%
5	2	16.7%
3	2	16.7%
2	1	8.3%
9	1	8.3%

Other Letter

Value	Count	Frequency (%)
雨	1	50.0%
婷	1	50.0%

Space Separator

Value	Count	Frequency (%)
	2888	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	155	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	50	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	50	100.0%

Math Symbol

Value	Count	Frequency (%)
+	10	100.0%

Other Symbol

Value	Count	Frequency (%)
★	6	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	122045	96.8%
Common	4086	3.2%
Cyrillic	6	< 0.1%
Han	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14096	11.5%
e	14076	11.5%
i	10788	8.8%
n	10549	8.6%
r	8367	6.9%
l	5733	4.7%
o	5579	4.6%
t	4821	4.0%
s	4089	3.4%
M	3150	2.6%
Other values (67)	40797	33.4%

Common

Value	Count	Frequency (%)
	2888	70.7%
&	768	18.8%
-	155	3.8%
.	95	2.3%
(	50	1.2%
)	50	1.2%
,	35	0.9%
+	10	0.2%
'	8	0.2%
★	6	0.1%
Other values (9)	21	0.5%

Cyrillic

Value	Count	Frequency (%)
а	2	33.3%
с	1	16.7%
О	1	16.7%
к	1	16.7%
н	1	16.7%

Han

Value	Count	Frequency (%)
雨	1	50.0%
婷	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	125923	99.8%
None	202	0.2%
Misc Symbols	6	< 0.1%
Cyrillic	6	< 0.1%
CJK	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	14096	11.2%
e	14076	11.2%
i	10788	8.6%
n	10549	8.4%
r	8367	6.6%
l	5733	4.6%
o	5579	4.4%
t	4821	3.8%
s	4089	3.2%
M	3150	2.5%
Other values (59)	44675	35.5%

None

Value	Count	Frequency (%)
é	83	41.1%
ë	34	16.8%
è	19	9.4%
í	10	5.0%
ç	8	4.0%
ï	8	4.0%
á	7	3.5%
ö	4	2.0%
ü	4	2.0%
ı	3	1.5%
Other values (16)	22	10.9%

Misc Symbols

Value	Count	Frequency (%)
★	6	100.0%

Cyrillic

Value	Count	Frequency (%)
а	2	33.3%
с	1	16.7%
О	1	16.7%
к	1	16.7%
н	1	16.7%

CJK

Value	Count	Frequency (%)
雨	1	50.0%
婷	1	50.0%

neighbourhood_group
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	20030
Missing (%)	100.0%
Memory size	156.6 KiB

neighbourhood
Categorical

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.6 KiB

De Baarsjes - Oud-West	3515
De Pijp - Rivierenbuurt	2493
Centrum-West	2326
Centrum-Oost	1730
Westerpark	1490
Other values (17)	8476

Length

Max length	38
Median length	23
Mean length	15.978283
Min length	4

Characters and Unicode

Total characters	320045
Distinct characters	41
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Oostelijk Havengebied - Indische Buurt
2nd row	Westerpark
3rd row	Centrum-Oost
4th row	Centrum-West
5th row	Centrum-West

Common Values

Value	Count	Frequency (%)
De Baarsjes - Oud-West	3515	17.5%
De Pijp - Rivierenbuurt	2493	12.4%
Centrum-West	2326	11.6%
Centrum-Oost	1730	8.6%
Westerpark	1490	7.4%
Zuid	1441	7.2%
Oud-Oost	1282	6.4%
Bos en Lommer	1145	5.7%
Oostelijk Havengebied - Indische Buurt	959	4.8%
Oud-Noord	571	2.9%
Other values (12)	3078	15.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	8157	17.4%
de	6150	13.1%
baarsjes	3515	7.5%
oud-west	3515	7.5%
pijp	2493	5.3%
rivierenbuurt	2493	5.3%
centrum-west	2326	5.0%
centrum-oost	1730	3.7%
westerpark	1490	3.2%
zuid	1441	3.1%
Other values (27)	13534	28.9%

Most occurring characters

Value	Count	Frequency (%)
e	41836	13.1%
	26814	8.4%
r	24136	7.5%
s	22204	6.9%
t	21810	6.8%
u	19662	6.1%
-	18365	5.7%
i	13244	4.1%
a	13001	4.1%
d	11466	3.6%
Other values (31)	107507	33.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	226664	70.8%
Uppercase Letter	48202	15.1%
Space Separator	26814	8.4%
Dash Punctuation	18365	5.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	41836	18.5%
r	24136	10.6%
s	22204	9.8%
t	21810	9.6%
u	19662	8.7%
i	13244	5.8%
a	13001	5.7%
d	11466	5.1%
n	10913	4.8%
o	9938	4.4%
Other values (13)	38454	17.0%

Uppercase Letter

Value	Count	Frequency (%)
O	9851	20.4%
W	8203	17.0%
D	6272	13.0%
B	6088	12.6%
C	4167	8.6%
P	2493	5.2%
R	2493	5.2%
Z	2155	4.5%
I	1411	2.9%
N	1290	2.7%
Other values (6)	3779	7.8%

Space Separator

Value	Count	Frequency (%)
	26814	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	18365	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	274866	85.9%
Common	45179	14.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	41836	15.2%
r	24136	8.8%
s	22204	8.1%
t	21810	7.9%
u	19662	7.2%
i	13244	4.8%
a	13001	4.7%
d	11466	4.2%
n	10913	4.0%
o	9938	3.6%
Other values (29)	86656	31.5%

Common

Value	Count	Frequency (%)
	26814	59.4%
-	18365	40.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	320045	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	41836	13.1%
	26814	8.4%
r	24136	7.5%
s	22204	6.9%
t	21810	6.8%
u	19662	6.1%
-	18365	5.7%
i	13244	4.1%
a	13001	4.1%
d	11466	3.6%
Other values (31)	107507	33.6%

latitude
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	20030
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.365212

Minimum	52.288378
Maximum	52.424713
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	52.288378
5-th percentile	52.342687
Q1	52.355126
median	52.36459
Q3	52.375074
95-th percentile	52.39005
Maximum	52.424713
Range	0.13633432
Interquartile range (IQR)	0.019948024

Descriptive statistics

Standard deviation	0.015995991
Coefficient of variation (CV)	0.0003054698
Kurtosis	2.1181302
Mean	52.365212
Median Absolute Deviation (MAD)	0.0098915095
Skewness	-0.1977422
Sum	1048875.2
Variance	0.00025587173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52.36575451	1	< 0.1%
52.37934236	1	< 0.1%
52.34363541	1	< 0.1%
52.37879082	1	< 0.1%
52.35459348	1	< 0.1%
52.38561195	1	< 0.1%
52.37284509	1	< 0.1%
52.36991662	1	< 0.1%
52.35877933	1	< 0.1%
52.3961998	1	< 0.1%
Other values (20020)	20020	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
52.28837824	1	< 0.1%
52.28927442	1	< 0.1%
52.29030764	1	< 0.1%
52.29068744	1	< 0.1%
52.29109538	1	< 0.1%
52.29164386	1	< 0.1%
52.29178467	1	< 0.1%
52.29220885	1	< 0.1%
52.29277879	1	< 0.1%
52.29281904	1	< 0.1%

Value	Count	Frequency (%)
52.42471256	1	< 0.1%
52.42464056	1	< 0.1%
52.42399339	1	< 0.1%
52.42380134	1	< 0.1%
52.42364739	1	< 0.1%
52.42350166	1	< 0.1%
52.4234977	1	< 0.1%
52.42343234	1	< 0.1%
52.42336689	1	< 0.1%
52.42332129	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	20030
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8889774

Minimum	4.7532466
Maximum	5.027689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	4.7532466
5-th percentile	4.8445341
Q1	4.8635951
median	4.8863869
Q3	4.9082884
95-th percentile	4.9460886
Maximum	5.027689
Range	0.27444239
Interquartile range (IQR)	0.044693385

Descriptive statistics

Standard deviation	0.035573429
Coefficient of variation (CV)	0.0072762515
Kurtosis	1.1442911
Mean	4.8889774
Median Absolute Deviation (MAD)	0.022407105
Skewness	0.55247624
Sum	97926.216
Variance	0.0012654688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.941419235	1	< 0.1%
4.926475131	1	< 0.1%
4.925121865	1	< 0.1%
4.859313343	1	< 0.1%
4.923211504	1	< 0.1%
4.883201766	1	< 0.1%
4.894525181	1	< 0.1%
4.92743154	1	< 0.1%
4.920524682	1	< 0.1%
4.93293638	1	< 0.1%
Other values (20020)	20020	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.753246567	1	< 0.1%
4.759434181	1	< 0.1%
4.763264201	1	< 0.1%
4.765050687	1	< 0.1%
4.768451848	1	< 0.1%
4.772158795	1	< 0.1%
4.773175277	1	< 0.1%
4.775167687	1	< 0.1%
4.775504535	1	< 0.1%
4.775947779	1	< 0.1%

Value	Count	Frequency (%)
5.027688954	1	< 0.1%
5.026700926	1	< 0.1%
5.018401449	1	< 0.1%
5.018302533	1	< 0.1%
5.018060461	1	< 0.1%
5.017531443	1	< 0.1%
5.016975529	1	< 0.1%
5.013616381	1	< 0.1%
5.01355728	1	< 0.1%
5.013534319	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.6 KiB

Entire home/apt	15889
Private room	4076
Shared room	65

Length

Max length	15
Median length	15
Mean length	14.376535
Min length	11

Characters and Unicode

Total characters	287962
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	15889	79.3%
Private room	4076	20.3%
Shared room	65	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	15889	39.7%
home/apt	15889	39.7%
room	4141	10.3%
private	4076	10.2%
shared	65	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	35919	12.5%
t	35854	12.5%
o	24171	8.4%
r	24171	8.4%
a	20030	7.0%
	20030	7.0%
m	20030	7.0%
i	19965	6.9%
h	15954	5.5%
p	15889	5.5%
Other values (7)	55949	19.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	232013	80.6%
Space Separator	20030	7.0%
Uppercase Letter	20030	7.0%
Other Punctuation	15889	5.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	35919	15.5%
t	35854	15.5%
o	24171	10.4%
r	24171	10.4%
a	20030	8.6%
m	20030	8.6%
i	19965	8.6%
h	15954	6.9%
p	15889	6.8%
n	15889	6.8%
Other values (2)	4141	1.8%

Uppercase Letter

Value	Count	Frequency (%)
E	15889	79.3%
P	4076	20.3%
S	65	0.3%

Space Separator

Value	Count	Frequency (%)
	20030	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	15889	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	252043	87.5%
Common	35919	12.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	35919	14.3%
t	35854	14.2%
o	24171	9.6%
r	24171	9.6%
a	20030	7.9%
m	20030	7.9%
i	19965	7.9%
h	15954	6.3%
p	15889	6.3%
E	15889	6.3%
Other values (5)	24171	9.6%

Common

Value	Count	Frequency (%)
	20030	55.8%
/	15889	44.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	287962	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	35919	12.5%
t	35854	12.5%
o	24171	8.4%
r	24171	8.4%
a	20030	7.0%
	20030	7.0%
m	20030	7.0%
i	19965	6.9%
h	15954	5.5%
p	15889	5.5%
Other values (7)	55949	19.4%

price
Real number (ℝ)

Distinct	429
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.18118

Minimum	0
Maximum	8500
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	0
5-th percentile	60
Q1	96
median	125
Q3	175
95-th percentile	300
Maximum	8500
Range	8500
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	145.82898
Coefficient of variation (CV)	0.95825895
Kurtosis	1168.155
Mean	152.18118
Median Absolute Deviation (MAD)	35
Skewness	25.447702
Sum	3048189
Variance	21266.09
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	1209	6.0%
100	1117	5.6%
120	961	4.8%
200	667	3.3%
125	656	3.3%
110	563	2.8%
175	540	2.7%
90	531	2.7%
80	527	2.6%
130	525	2.6%
Other values (419)	12734	63.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
8	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
19	1	< 0.1%
20	2	< 0.1%
23	2	< 0.1%
24	1	< 0.1%
25	6	< 0.1%
26	4	< 0.1%

Value	Count	Frequency (%)
8500	1	< 0.1%
8000	1	< 0.1%
5040	1	< 0.1%
5000	1	< 0.1%
4500	1	< 0.1%
3900	1	< 0.1%
3142	1	< 0.1%
3000	1	< 0.1%
2500	2	< 0.1%
2200	1	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	51
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3287069

Minimum	1
Maximum	1001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	7
Maximum	1001
Range	1000
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	12.537419
Coefficient of variation (CV)	3.7664532
Kurtosis	4130.872
Mean	3.3287069
Median Absolute Deviation (MAD)	1
Skewness	56.361392
Sum	66674
Variance	157.18687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	8104	40.5%
3	4965	24.8%
1	3128	15.6%
4	1555	7.8%
5	982	4.9%
7	555	2.8%
6	243	1.2%
14	90	0.4%
10	82	0.4%
30	61	0.3%
Other values (41)	265	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3128	15.6%
2	8104	40.5%
3	4965	24.8%
4	1555	7.8%
5	982	4.9%
6	243	1.2%
7	555	2.8%
8	30	0.1%
9	17	0.1%
10	82	0.4%

Value	Count	Frequency (%)
1001	1	< 0.1%
999	1	< 0.1%
365	3	< 0.1%
300	1	< 0.1%
230	1	< 0.1%
222	1	< 0.1%
186	1	< 0.1%
185	1	< 0.1%
183	1	< 0.1%
181	1	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	354
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.560459

Minimum	0
Maximum	695
Zeros	2388
Zeros (%)	11.9%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	8
Q3	22
95-th percentile	85
Maximum	695
Range	695
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	43.240292
Coefficient of variation (CV)	2.0055367
Kurtosis	41.501917
Mean	21.560459
Median Absolute Deviation (MAD)	7
Skewness	5.4150261
Sum	431856
Variance	1869.7228
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2388	11.9%
1	1408	7.0%
2	1198	6.0%
3	1071	5.3%
4	956	4.8%
5	857	4.3%
6	779	3.9%
7	725	3.6%
8	651	3.3%
9	586	2.9%
Other values (344)	9411	47.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2388	11.9%
1	1408	7.0%
2	1198	6.0%
3	1071	5.3%
4	956	4.8%
5	857	4.3%
6	779	3.9%
7	725	3.6%
8	651	3.3%
9	586	2.9%

Value	Count	Frequency (%)
695	1	< 0.1%
631	1	< 0.1%
606	1	< 0.1%
602	1	< 0.1%
580	1	< 0.1%
576	1	< 0.1%
574	1	< 0.1%
541	1	< 0.1%
540	1	< 0.1%
527	1	< 0.1%

last_review
Categorical

HIGH CARDINALITY MISSING

Distinct	1202
Distinct (%)	6.8%
Missing	2406
Missing (%)	12.0%
Memory size	156.6 KiB

2018-12-02	492
2018-11-18	472
2018-11-25	457
2018-10-21	350
2018-11-04	345
Other values (1197)	15508

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	176240
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	264 ?
Unique (%)	1.5%

Sample

1st row	2018-11-28
2nd row	2018-08-29
3rd row	2018-11-30
4th row	2018-01-21
5th row	2018-11-25

Common Values

Value	Count	Frequency (%)
2018-12-02	492	2.5%
2018-11-18	472	2.4%
2018-11-25	457	2.3%
2018-10-21	350	1.7%
2018-11-04	345	1.7%
2018-10-22	279	1.4%
2018-12-03	270	1.3%
2018-11-19	235	1.2%
2018-11-11	230	1.1%
2018-10-28	221	1.1%
Other values (1192)	14273	71.3%
(Missing)	2406	12.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-12-02	492	2.8%
2018-11-18	472	2.7%
2018-11-25	457	2.6%
2018-10-21	350	2.0%
2018-11-04	345	2.0%
2018-10-22	279	1.6%
2018-12-03	270	1.5%
2018-11-19	235	1.3%
2018-11-11	230	1.3%
2018-10-28	221	1.3%
Other values (1192)	14273	81.0%

Most occurring characters

Value	Count	Frequency (%)
1	37787	21.4%
0	36612	20.8%
-	35248	20.0%
2	27701	15.7%
8	17594	10.0%
7	5646	3.2%
6	3669	2.1%
9	3625	2.1%
5	3088	1.8%
3	2843	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	140992	80.0%
Dash Punctuation	35248	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	37787	26.8%
0	36612	26.0%
2	27701	19.6%
8	17594	12.5%
7	5646	4.0%
6	3669	2.6%
9	3625	2.6%
5	3088	2.2%
3	2843	2.0%
4	2427	1.7%

Dash Punctuation

Value	Count	Frequency (%)
-	35248	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	176240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	37787	21.4%
0	36612	20.8%
-	35248	20.0%
2	27701	15.7%
8	17594	10.0%
7	5646	3.2%
6	3669	2.1%
9	3625	2.1%
5	3088	1.8%
3	2843	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	176240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	37787	21.4%
0	36612	20.8%
-	35248	20.0%
2	27701	15.7%
8	17594	10.0%
7	5646	3.2%
6	3669	2.1%
9	3625	2.1%
5	3088	1.8%
3	2843	1.6%

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	754
Distinct (%)	4.3%
Missing	2406
Missing (%)	12.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0620801

Minimum	0.01
Maximum	11.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.07
Q1	0.27
median	0.62
Q3	1.23
95-th percentile	4
Maximum	11.85
Range	11.84
Interquartile range (IQR)	0.96

Descriptive statistics

Standard deviation	1.3333201
Coefficient of variation (CV)	1.2553856
Kurtosis	9.2001935
Mean	1.0620801
Median Absolute Deviation (MAD)	0.41
Skewness	2.7343685
Sum	18718.1
Variance	1.7777425
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.03	239	1.2%
0.07	238	1.2%
1	236	1.2%
0.25	211	1.1%
0.06	208	1.0%
0.18	205	1.0%
0.27	199	1.0%
0.17	193	1.0%
0.1	192	1.0%
0.2	181	0.9%
Other values (744)	15522	77.5%
(Missing)	2406	12.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	5	< 0.1%
0.02	75	0.4%
0.03	239	1.2%
0.04	163	0.8%
0.05	153	0.8%
0.06	208	1.0%
0.07	238	1.2%
0.08	145	0.7%
0.09	157	0.8%
0.1	192	1.0%

Value	Count	Frequency (%)
11.85	1	< 0.1%
11.58	1	< 0.1%
11.44	1	< 0.1%
11.09	1	< 0.1%
10.96	1	< 0.1%
10.86	1	< 0.1%
10.68	1	< 0.1%
10.15	1	< 0.1%
10.12	1	< 0.1%
10.01	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.734698

Minimum	1
Maximum	208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	6
Maximum	208
Range	207
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	22.921886
Coefficient of variation (CV)	4.8412563
Kurtosis	63.73466
Mean	4.734698
Median Absolute Deviation (MAD)	0
Skewness	7.8549484
Sum	94836
Variance	525.41286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	15830	79.0%
2	2208	11.0%
3	522	2.6%
208	208	1.0%
4	200	1.0%
5	185	0.9%
6	144	0.7%
105	105	0.5%
83	83	0.4%
7	63	0.3%
Other values (17)	482	2.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	15830	79.0%
2	2208	11.0%
3	522	2.6%
4	200	1.0%
5	185	0.9%
6	144	0.7%
7	63	0.3%
8	48	0.2%
9	36	0.2%
10	30	0.1%

Value	Count	Frequency (%)
208	208	1.0%
105	105	0.5%
83	83	0.4%
38	38	0.2%
30	30	0.1%
27	27	0.1%
25	25	0.1%
24	24	0.1%
21	42	0.2%
19	38	0.2%

availability_365
Real number (ℝ)

Distinct	366
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.913679

Minimum	0
Maximum	365
Zeros	9344
Zeros (%)	46.7%
Negative	0
Negative (%)	0.0%
Memory size	156.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	67
95-th percentile	336
Maximum	365
Range	365
Interquartile range (IQR)	67

Descriptive statistics

Standard deviation	104.02771
Coefficient of variation (CV)	1.7362931
Kurtosis	1.9994437
Mean	59.913679
Median Absolute Deviation (MAD)	3
Skewness	1.8194251
Sum	1200071
Variance	10821.765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9344	46.7%
5	245	1.2%
3	244	1.2%
4	241	1.2%
7	239	1.2%
2	235	1.2%
6	228	1.1%
1	225	1.1%
8	213	1.1%
9	196	1.0%
Other values (356)	8620	43.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9344	46.7%
1	225	1.1%
2	235	1.2%
3	244	1.2%
4	241	1.2%
5	245	1.2%
6	228	1.1%
7	239	1.2%
8	213	1.1%
9	196	1.0%

Value	Count	Frequency (%)
365	66	0.3%
364	162	0.8%
363	46	0.2%
362	44	0.2%
361	39	0.2%
360	28	0.1%
359	30	0.1%
358	42	0.2%
357	40	0.2%
356	28	0.1%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	neighbourhood	room_type
id	1.000	0.463	-0.010	0.004	0.026	-0.120	-0.453	0.269	0.125	0.067	0.039	0.054
host_id	0.463	1.000	-0.018	0.036	-0.023	-0.139	-0.200	0.123	0.028	-0.005	0.055	0.061
latitude	-0.010	-0.018	1.000	-0.127	0.000	0.002	0.067	0.062	0.038	0.027	0.679	0.079
longitude	0.004	0.036	-0.127	1.000	0.047	0.017	0.005	0.016	0.011	0.027	0.664	0.095
price	0.026	-0.023	0.000	0.047	1.000	0.116	-0.065	-0.054	-0.032	0.149	0.007	0.000
minimum_nights	-0.120	-0.139	0.002	0.017	0.116	1.000	-0.080	-0.206	-0.079	-0.003	0.006	0.000
number_of_reviews	-0.453	-0.200	0.067	0.005	-0.065	-0.080	1.000	0.650	0.013	0.260	0.033	0.226
reviews_per_month	0.269	0.123	0.062	0.016	-0.054	-0.206	0.650	1.000	0.160	0.421	0.064	0.316
calculated_host_listings_count	0.125	0.028	0.038	0.011	-0.032	-0.079	0.013	0.160	1.000	0.204	0.042	0.053
availability_365	0.067	-0.005	0.027	0.027	0.149	-0.003	0.260	0.421	0.204	1.000	0.067	0.167
neighbourhood	0.039	0.055	0.679	0.664	0.007	0.006	0.033	0.064	0.042	0.067	1.000	0.139
room_type	0.054	0.061	0.079	0.095	0.000	0.000	0.226	0.316	0.053	0.167	0.139	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	2818	Quiet Garden View Room & Super Fast WiFi	3159	Daniel	NaN	Oostelijk Havengebied - Indische Buurt	52.365755	4.941419	Private room	59	3	248	2018-11-28	2.10	1	44
1	3209	Quiet apt near center, great view	3806	Maartje	NaN	Westerpark	52.390225	4.873924	Entire home/apt	160	4	42	2018-08-29	1.03	1	47
2	20168	100%Centre-Studio 1 Private Floor/Bathroom	59484	Alex	NaN	Centrum-Oost	52.365087	4.893541	Entire home/apt	80	1	233	2018-11-30	2.18	2	198
3	25428	Lovely apt in City Centre (Jordaan)	56142	Joan	NaN	Centrum-West	52.373114	4.883668	Entire home/apt	125	14	1	2018-01-21	0.09	2	141
4	27886	Romantic, stylish B&B houseboat in canal district	97647	Flip	NaN	Centrum-West	52.386727	4.892078	Private room	150	2	171	2018-11-25	2.03	1	199
5	28658	Cosy guest room near city centre -1	123414	Michele	NaN	Bos en Lommer	52.375342	4.857289	Private room	65	3	434	2018-11-19	4.16	2	295
6	28871	Comfortable double room	124245	Edwin	NaN	Centrum-West	52.367187	4.890918	Private room	75	2	215	2018-12-03	2.13	3	137
7	29051	Comfortable single room	124245	Edwin	NaN	Centrum-West	52.367725	4.891512	Private room	55	2	383	2018-12-05	4.07	3	188
8	31080	2-story apartment + rooftop terrace	133488	Nienke	NaN	Zuid	52.351321	4.848383	Entire home/apt	219	3	32	2017-10-16	0.36	1	336
9	41125	Amsterdam Center Entire Apartment	178515	Fatih	NaN	Centrum-West	52.378915	4.883205	Entire home/apt	180	3	76	2018-10-07	0.78	1	11

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	last_review	reviews_per_month	calculated_host_listings_count	availability_365
20020	30561688	Cozy apartment close to the center of Amsterdam	228892275	Joel	NaN	Osdorp	52.357365	4.784800	Entire home/apt	150	1	NaN	NaN	1	34
20021	30562273	Designer & charming apartment in Oud-Zuid	853028	Elisa	NaN	Zuid	52.351766	4.853029	Entire home/apt	150	2	NaN	NaN	1	23
20022	30562689	Cosy two floor apartment with a big terrace	229295710	Mariana & Rob	NaN	Watergraafsmeer	52.356327	4.933991	Entire home/apt	80	5	NaN	NaN	1	234
20023	30563877	Large comfortable apartments in the center	228749822	Rozaliia	NaN	Centrum-Oost	52.365812	4.896044	Entire home/apt	200	7	NaN	NaN	1	30
20024	30573892	Clean and perfect location	229361236	Poppy	NaN	De Baarsjes - Oud-West	52.363901	4.878162	Entire home/apt	81	1	NaN	NaN	1	133
20025	30576148	Family House City + free Parking+garden (160 m2)	13399651	Marieke	NaN	Watergraafsmeer	52.345999	4.952145	Entire home/apt	340	7	NaN	NaN	1	11
20026	30577727	Home Sweet Home in Indische Buurt	1595885	Evita	NaN	Oostelijk Havengebied - Indische Buurt	52.362412	4.932467	Entire home/apt	150	3	NaN	NaN	2	16
20027	30578037	Amsterdam Cozy apartment nearby center	87866499	Tommaso	NaN	Oud-Oost	52.362431	4.926912	Entire home/apt	80	10	NaN	NaN	2	210
20028	30579673	Home Sweet Home for a Guest or a Couple	1595885	Evita	NaN	Oostelijk Havengebied - Indische Buurt	52.363780	4.932493	Private room	55	2	NaN	NaN	2	31
20029	30580413	Cosy two bedroom appartment near 'de Pijp'!	27212057	Lisa	NaN	De Pijp - Rivierenbuurt	52.346911	4.901932	Entire home/apt	220	5	NaN	NaN	1	14

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Uppercase Letter

Other Symbol

Other Punctuation

Decimal Number

Math Symbol

Close Punctuation

Open Punctuation

Modifier Symbol

Space Separator

Dash Punctuation

Final Punctuation

Nonspacing Mark

Initial Punctuation

Currency Symbol

Other Number

Control

Connector Punctuation

Modifier Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Han

Katakana

Inherited

Cyrillic

Hiragana

Most occurring blocks

Most frequent character per block

ASCII

Misc Symbols

Punctuation

None

VS

Dingbats

Modifier Letters

Geometric Shapes

CJK

Misc Technical

Cyrillic

Hiragana

Math Operators

Currency Symbols

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Other Letter

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Other Symbol

Connector Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Cyrillic

Han

Most occurring blocks

Most frequent character per block

ASCII

None